<HTML><HEAD><TITLE>cursor_all_execute(++Cursor, +TupleList)</TITLE>
</HEAD><BODY>[ <A HREF="index.html">library(dbi)</A> | <A HREF="../../index.html">Reference Manual</A> | <A HREF="../../fullindex.html">Alphabetic Index</A> ]
<H1>cursor_all_execute(++Cursor, +TupleList)</H1>
Executes the parametrised prepared SQL statement represented by Cursor, once for each tuple in TupleList.
<DL>
<DT><EM>Cursor</EM></DT>
<DD>A cursor handle
</DD>
<DT><EM>TupleList</EM></DT>
<DD>A list of tuples of parameter values matching the template for this cursor
</DD>
</DL>
<H2>Description</H2>
<P>
 Executes the parameterised prepared SQL statement represented by Cursor,
 previously prepared by session_sql_prepare/4 or session_sql_prepare_query/5.
 The statement is executed once for each tuple in TupleList, with the 
 parameter values supplied by that tuple. The tuples are executed in the
 order they are in TupleList, and any results produced are discarded when
 the next tuple is executed.
</P><P>
 Each tuple is a structure whose name and arity match the parameter
 template when Cursor was prepared, and the arguments give the values for
 the parameters for this execution, and must be compatible with the type
 specified by the template, except that an argument can be an
 uninstantiated variable, to denote a NULL value for the corresponding
 parameter.
<H3>Exceptions</H3>
<DL>
<DT><EM>(5) type error </EM>
<DD>Cursor is not a valid cursor handle
<DT><EM>(5) type error </EM>
<DD>Type mismatch between parameter template specification for Cursor and actual tuple data
<DT><EM>(dbi_error) </EM>
<DD>Error from DBMS while executing SQL associated with Cursor.
<DT><EM>(dbi_bad_template) </EM>
<DD>ParamTemplate not specified when Cursor was created
</DL>
<H2>See Also</H2>
<A HREF="../../lib/dbi/cursor_next_execute-2.html">cursor_next_execute / 2</A>, <A HREF="../../lib/dbi/cursor_N_execute-4.html">cursor_N_execute / 4</A>, <A HREF="../../lib/dbi/session_sql_prepare-4.html">session_sql_prepare / 4</A>, <A HREF="../../lib/dbi/session_sql_prepare_query-5.html">session_sql_prepare_query / 5</A>
</BODY></HTML>
